import openpyxl

# load_workbook 打开已存在的表格，结果为工作簿对象
# workbook.sheetnames 工作簿对象的属性，获取所有表的名称，结果是列表类型

workbook = openpyxl.load_workbook('景区天气.xlsx')
print(workbook.sheetnames) # ['表格1', '景区天气']
sheet=workbook['景区天气']

lst = []
for row in sheet.rows:
    sublist = []
    for cell in row:
        sublist.append(cell.value)
    lst.append(sublist)

for item in lst:
    print(item)